17 | "Problem" with cross join=InheritanceType.JOINED) ... @ManyToOne private CI ci; subclass CIstring private String text; I ... primary key fields in JOIN queries). Please try the new build (2.0.4_01) that should fix the bug |
16 | joining of tablesHi In objectdb site i found :Note: This ORM/SQL annotation is silently ignored by ObjectDB so i want join tow table and generate a third table. Ex: table 1: employee table 2: address and the generate table will be table 3: emp_add employee: e_id, e_name address: add_id, city, house |
3 | Index Definition JOIN queries: SELECT d FROM Document d JOIN d.words w WHERE w = 'JPA' The Document entity class ... can also be used for executing the following query: SELECT d FROM Document d JOIN d.words w |
3 | Mapped by fields are not initialized by JOIN FETCH in queriesAs demonstrated in this forum thread, a mapped by collection field with lazy fetch mode is not initialized in results of a query that uses JOIN FETCH on that collection field (when enhancement is used). support Support Build 2.4.1_06 fixes this issue (fields are now initialized and the test in |
3 | Different behavior for two equal queries components. Navigation should be compiled as LEFT OUTER JOIN to avoid losing results in such cases, but maybe an ordinary JOIN was used in this query. Could you isolate the OR component that causes this query |
3 | ObjectDB 2.4.0 (by catching unexpected exception). Fixed LEFT [OUTER] JOIN issues (including on mapped by ... . Fixed handling null values in JOIN and path expressions in queries. Fixed a possibly very slow query |
3 | ObjectDB 2.3.6 in the default fetch policy. Fixed a new bug in retrieving byte[] (issue #624). Fixed a bug in LEFT OUTER JOIN. Fixed GROUP BY DATE(...) - merging AM and PM into the same date. |
3 | ObjectDB 2.2.8Fixed a critical bug in extensive removal operations of large objects. Improved the performance of navigation through an inverse (mapped by) field if the owner field is indexed. Fixed a LEFT OUTER JOIN bug. Fixed a bug in parsing queries with parenthesis followed by NOT. Fixed a bug in running |
3 | New issues with queries using build 2.7.8Hello, we found another query bug: SELECT a FROM ArtifactImpl a LEFT OUTER JOIN a.tcSignal s WHERE a.startStep.stepNumber <= 2 AND a.endStep.stepNumber >= 0 AND (s.name IN ('In1') OR a.tcSignal IS NULL) With 2.7.6_b6 we get the expected three result objects. But with 2.8.0 we get only two result |
0 | addSubquery(sub, variableDeclaration, candidateCollectionExpression, parameters) a Query and subsequently attached to a different query (the outer query) by calling this method ... of the outer query. Only some of the query parts are copied for use as the subquery. The parts copied ... the outer query that represents the candidates over which the subquery is evaluated. If the trimmed |
